Dataset info
| Number of variables | 49 |
|---|---|
| Number of observations | 200000 |
| Missing cells | 694994 (7.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 69.3 MiB |
| Average record size in memory | 363.2 B |
Variables types
| Numeric | 13 |
|---|---|
| Categorical | 18 |
| Boolean | 15 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 2 |
| Unsupported | 0 |
Warnings
de_faixa_faturamento_estimado has 11885 (5.9%) missing values | Missing |
de_faixa_faturamento_estimado_grupo has 11885 (5.9%) missing values | Missing |
de_natureza_juridica has a high cardinality: 63 distinct values | Warning |
de_nivel_atividade has 4721 (2.4%) missing values | Missing |
de_saude_rescencia has 6356 (3.2%) missing values | Missing |
de_saude_tributaria has 6356 (3.2%) missing values | Missing |
dt_situacao has a high cardinality: 6495 distinct values | Warning |
empsetorcensitariofaixarendapopulacao has 62448 (31.2%) missing values | Missing |
fl_epp has constant value "False" | Rejected |
fl_optante_simei has 35727 (17.9%) missing values | Missing |
fl_optante_simples has 35727 (17.9%) missing values | Missing |
idade_media_socios has 65438 (32.7%) missing values | Missing |
nm_divisao has a high cardinality: 87 distinct values | Warning |
nm_meso_regiao has 25254 (12.6%) missing values | Missing |
nm_micro_regiao has a high cardinality: 74 distinct values | Warning |
nm_micro_regiao has 25254 (12.6%) missing values | Missing |
nu_meses_rescencia has 19547 (9.8%) missing values | Missing |
qt_filiais has 180959 (90.5%) zeros | Zeros |
qt_socios is highly skewed (γ1 = 26.71097273) | Skewed |
qt_socios has 49616 (24.8%) missing values | Missing |
qt_socios_feminino is highly skewed (γ1 = 56.06299548) | Skewed |
qt_socios_feminino has 137299 (68.6%) missing values | Missing |
qt_socios_masculino is highly correlated with qt_socios (ρ = 0.9711913029) | Rejected |
qt_socios_pj has 148477 (74.2%) zeros | Zeros |
qt_socios_pj has 49616 (24.8%) missing values | Missing |
vl_faturamento_estimado_aux is highly skewed (γ1 = 346.5212661) | Skewed |
vl_faturamento_estimado_aux has 11885 (5.9%) missing values | Missing |
vl_faturamento_estimado_grupo_aux is highly skewed (γ1 = 28.13600343) | Skewed |
vl_faturamento_estimado_grupo_aux has 11885 (5.9%) missing values | Missing |
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 35.27165009) | Skewed |
vl_total_veiculos_leves_grupo has 183714 (91.9%) zeros | Zeros |
vl_total_veiculos_pesados_grupo is highly skewed (γ1 = 27.93113919) | Skewed |
vl_total_veiculos_pesados_grupo has 191111 (95.6%) zeros | Zeros |
de_faixa_faturamento_estimado
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.9% |
| Missing (n) | 11885 |
| DE R$ 81.000,01 A R$ 360.000,00 | |
|---|---|
| ATE R$ 81.000,00 | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 20014 |
| Other values (9) | 6927 |
| (Missing) | 11885 |
| Value | Count | Frequency (%) | |
| DE R$ 81.000,01 A R$ 360.000,00 | 118455 | 59.2% | |
| ATE R$ 81.000,00 | 42719 | 21.4% | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 20014 | 10.0% | |
| DE R$ 1.500.000,01 A R$ 4.800.000,00 | 4384 | 2.2% | |
| DE R$ 4.800.000,01 A R$ 10.000.000,00 | 906 | 0.5% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 629 | 0.3% | |
| SEM INFORMACAO | 507 | 0.3% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 352 | 0.2% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 111 | 0.1% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 21 | < 0.1% | |
| Other values (2) | 17 | < 0.1% | |
| (Missing) | 11885 | 5.9% |
| Max length | 40 |
|---|---|
| Mean length | 26.56831 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_faixa_faturamento_estimado_grupo
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.9% |
| Missing (n) | 11885 |
| DE R$ 81.000,01 A R$ 360.000,00 | |
|---|---|
| ATE R$ 81.000,00 | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | |
| Other values (8) | 13210 |
| (Missing) | 11885 |
| Value | Count | Frequency (%) | |
| DE R$ 81.000,01 A R$ 360.000,00 | 109328 | 54.7% | |
| ATE R$ 81.000,00 | 42512 | 21.3% | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 23065 | 11.5% | |
| DE R$ 1.500.000,01 A R$ 4.800.000,00 | 5858 | 2.9% | |
| DE R$ 4.800.000,01 A R$ 10.000.000,00 | 1768 | 0.9% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 1622 | 0.8% | |
| ACIMA DE 1 BILHAO DE REAIS | 1507 | 0.8% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 1272 | 0.6% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 660 | 0.3% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 291 | 0.1% | |
| (Missing) | 11885 | 5.9% |
| Max length | 40 |
|---|---|
| Mean length | 26.816375 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_natureza_juridica
Categorical
| Distinct count | 63 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| EMPRESARIO INDIVIDUAL | |
|---|---|
| SOCIEDADE EMPRESARIA LIMITADA | |
| ASSOCIACAO PRIVADA | 12883 |
| Other values (60) | 19701 |
| Value | Count | Frequency (%) | |
| EMPRESARIO INDIVIDUAL | 127984 | 64.0% | |
| SOCIEDADE EMPRESARIA LIMITADA | 39432 | 19.7% | |
| ASSOCIACAO PRIVADA | 12883 | 6.4% | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 6560 | 3.3% | |
| ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO | 3129 | 1.6% | |
| ORGANIZACAO RELIGIOSA | 1275 | 0.6% | |
| SOCIEDADE ANONIMA FECHADA | 949 | 0.5% | |
| CONDOMINIO EDILICIO | 887 | 0.4% | |
| ENTIDADE SINDICAL | 770 | 0.4% | |
| CANDIDATO A CARGO POLITICO ELETIVO | 693 | 0.3% | |
| Other values (53) | 5438 | 2.7% |
| Max length | 70 |
|---|---|
| Mean length | 24.489855 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_nivel_atividade
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 2.4% |
| Missing (n) | 4721 |
| MEDIA | |
|---|---|
| ALTA | |
| BAIXA | |
| (Missing) | 4721 |
| Value | Count | Frequency (%) | |
| MEDIA | 94617 | 47.3% | |
| ALTA | 65726 | 32.9% | |
| BAIXA | 32889 | 16.4% | |
| MUITO BAIXA | 2047 | 1.0% | |
| (Missing) | 4721 | 2.4% |
| Max length | 11 |
|---|---|
| Mean length | 4.68557 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_ramo
Categorical
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| COMERCIO VAREJISTA | |
|---|---|
| SERVICOS DIVERSOS | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 13022 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| COMERCIO VAREJISTA | 74773 | 37.4% | |
| SERVICOS DIVERSOS | 26040 | 13.0% | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 13022 | 6.5% | |
| INDUSTRIA DA CONSTRUCAO | 11037 | 5.5% | |
| COMERCIO E REPARACAO DE VEICULOS | 9633 | 4.8% | |
| BENS DE CONSUMO | 9311 | 4.7% | |
| SERVICOS ADMINISTRATIVOS | 9216 | 4.6% | |
| SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | 7452 | 3.7% | |
| COMERCIO POR ATACADO | 7092 | 3.5% | |
| TRANSPORTE, ARMAZENAGEM E CORREIO | 6618 | 3.3% | |
| Other values (23) | 25806 | 12.9% |
| Max length | 49 |
|---|---|
| Mean length | 22.054005 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_saude_rescencia
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 3.2% |
| Missing (n) | 6356 |
| ACIMA DE 1 ANO | |
|---|---|
| ATE 1 ANO | 16486 |
| SEM INFORMACAO | 13191 |
| Other values (2) | 7 |
| (Missing) | 6356 |
| Value | Count | Frequency (%) | |
| ACIMA DE 1 ANO | 163960 | 82.0% | |
| ATE 1 ANO | 16486 | 8.2% | |
| SEM INFORMACAO | 13191 | 6.6% | |
| ATE 3 MESES | 6 | < 0.1% | |
| ATE 6 MESES | 1 | < 0.1% | |
| (Missing) | 6356 | 3.2% |
| Max length | 14 |
|---|---|
| Mean length | 13.238165 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_saude_tributaria
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 3.2% |
| Missing (n) | 6356 |
| VERDE | |
|---|---|
| AZUL | |
| AMARELO | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| VERDE | 62976 | 31.5% | |
| AZUL | 45670 | 22.8% | |
| AMARELO | 39297 | 19.6% | |
| CINZA | 27688 | 13.8% | |
| LARANJA | 15616 | 7.8% | |
| VERMELHO | 2397 | 1.2% | |
| (Missing) | 6356 | 3.2% |
| Max length | 8 |
|---|---|
| Mean length | 5.293175 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
dt_situacao
Categorical
| Distinct count | 6495 |
|---|---|
| Unique (%) | 3.2% |
| Missing (%) | < 0.1% |
| Missing (n) | 2 |
| 2005-11-03 | 30087 |
|---|---|
| 2006-12-21 | 967 |
| 2006-12-01 | 891 |
| Other values (6491) |
| Value | Count | Frequency (%) | |
| 2005-11-03 | 30087 | 15.0% | |
| 2006-12-21 | 967 | 0.5% | |
| 2006-12-01 | 891 | 0.4% | |
| 2010-05-15 | 771 | 0.4% | |
| 2005-09-24 | 679 | 0.3% | |
| 2006-12-02 | 645 | 0.3% | |
| 1998-07-28 | 644 | 0.3% | |
| 2005-08-27 | 584 | 0.3% | |
| 2004-10-30 | 408 | 0.2% | |
| 2001-07-01 | 390 | 0.2% | |
| Other values (6484) | 163932 | 82.0% |
| Max length | 10 |
|---|---|
| Mean length | 9.99993 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
empsetorcensitariofaixarendapopulacao
Numeric
| Distinct count | 14072 |
|---|---|
| Unique (%) | 7.0% |
| Missing (%) | 31.2% |
| Missing (n) | 62448 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1302.532581 |
|---|---|
| Minimum | 100 |
| Maximum | 75093.84 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 424.291 |
| Q1 | 670.68 |
| Median | 944.94 |
| Q3 | 1511.81 |
| 95-th percentile | 3516.495 |
| Maximum | 75093.84 |
| Range | 74993.84 |
| Interquartile range | 841.13 |
Descriptive statistics
| Standard deviation | 1147.151209 |
|---|---|
| Coef of variation | 0.8807082641 |
| Kurtosis | 409.4083295 |
| Mean | 1302.532581 |
| MAD | 715.9528233 |
| Skewness | 9.22983695 |
| Sum | 179165961.7 |
| Variance | 1315955.896 |
| Memory size | 3.1 MiB |
| Value | Count | Frequency (%) | |
| 1549.1 | 864 | 0.4% | |
| 2361.38 | 363 | 0.2% | |
| 1086.05 | 317 | 0.2% | |
| 3940.05 | 241 | 0.1% | |
| 786.74 | 211 | 0.1% | |
| 3321.86 | 206 | 0.1% | |
| 2679.5 | 198 | 0.1% | |
| 2019.39 | 196 | 0.1% | |
| 1692.92 | 194 | 0.1% | |
| 1910.81 | 191 | 0.1% | |
| Other values (14061) | 134571 | 67.3% | |
| (Missing) | 62448 | 31.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 100 | 2 | < 0.1% | |
| 110.3 | 24 | < 0.1% | |
| 151.35 | 1 | < 0.1% | |
| 169.28 | 18 | < 0.1% | |
| 172.68 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 75093.84 | 3 | < 0.1% | |
| 30861.81 | 8 | < 0.1% | |
| 13793 | 10 | < 0.1% | |
| 12512.93 | 51 | < 0.1% | |
| 11281.03 | 2 | < 0.1% |
fl_antt
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| False | |
|---|---|
| True | 1389 |
| (Missing) | 792 |
| Value | Count | Frequency (%) | |
| False | 197819 | 98.9% | |
| True | 1389 | 0.7% | |
| (Missing) | 792 | 0.4% |
fl_email
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 110674 | 55.3% | |
| True | 89326 | 44.7% |
fl_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_ltda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 522 |
| Value | Count | Frequency (%) | |
| False | 199478 | 99.7% | |
| True | 522 | 0.3% |
fl_matriz
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False | 12532 |
| Value | Count | Frequency (%) | |
| True | 187468 | 93.7% | |
| False | 12532 | 6.3% |
fl_me
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 485 |
| Value | Count | Frequency (%) | |
| False | 199515 | 99.8% | |
| True | 485 | 0.2% |
fl_mei
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 134640 | 67.3% | |
| True | 65360 | 32.7% |
fl_optante_simei
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 17.9% |
| Missing (n) | 35727 |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 123510 | 61.8% | |
| True | 40763 | 20.4% | |
| (Missing) | 35727 | 17.9% |
fl_optante_simples
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 17.9% |
| Missing (n) | 35727 |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) | |
| True | 86493 | 43.2% | |
| False | 77780 | 38.9% | |
| (Missing) | 35727 | 17.9% |
fl_passivel_iss
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| True | |
|---|---|
| False | |
| (Missing) | 792 |
| Value | Count | Frequency (%) | |
| True | 114393 | 57.2% | |
| False | 84815 | 42.4% | |
| (Missing) | 792 | 0.4% |
fl_rm
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| NAO | |
|---|---|
| SIM |
| Value | Count | Frequency (%) | |
| NAO | 102598 | 51.3% | |
| SIM | 97402 | 48.7% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
fl_sa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 3617 |
| Value | Count | Frequency (%) | |
| False | 196383 | 98.2% | |
| True | 3617 | 1.8% |
fl_simples_irregular
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| False | |
|---|---|
| True | 162 |
| (Missing) | 792 |
| Value | Count | Frequency (%) | |
| False | 199046 | 99.5% | |
| True | 162 | 0.1% | |
| (Missing) | 792 | 0.4% |
fl_spa
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| False | |
|---|---|
| True | 99 |
| (Missing) | 792 |
| Value | Count | Frequency (%) | |
| False | 199109 | 99.6% | |
| True | 99 | < 0.1% | |
| (Missing) | 792 | 0.4% |
fl_st_especial
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 33 |
| Value | Count | Frequency (%) | |
| False | 199967 | > 99.9% | |
| True | 33 | < 0.1% |
fl_telefone
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 145216 | 72.6% | |
| False | 54784 | 27.4% |
fl_veiculo
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| False | |
|---|---|
| True | 13190 |
| (Missing) | 792 |
| Value | Count | Frequency (%) | |
| False | 186018 | 93.0% | |
| True | 13190 | 6.6% | |
| (Missing) | 792 | 0.4% |
id
Categorical, Unique
| First 5 values |
|---|
| 000001857eec66f7d67ea918825c9980eebff5c10b36f3... |
| 0000133f443484b40bc632e3b8595c8348441b3899973f... |
| 000061121bf1a98d79c02f156af0cadec80ea1c68236e6... |
| 0000bf5a53db23cf7ccbe510f95c423b97f9604546d584... |
| 00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb... |
| Last 5 values |
|---|
| fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45... |
| ffff04db2ba37d91b738fdac887d5744018d10c4d5504f... |
| ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb... |
| ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd... |
| ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45... |
First 5 values
| Value | Count | Frequency (%) | |
| 000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3 | 1 | < 0.1% | |
| 0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88 | 1 | < 0.1% | |
| 000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78 | 1 | < 0.1% | |
| 0000bf5a53db23cf7ccbe510f95c423b97f9604546d584b33b0054a411cf9429 | 1 | < 0.1% | |
| 00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb4f459b464fb1a40e56 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45acb7af4baee64b373a | 1 | < 0.1% | |
| ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd14692ec66879869148 | 1 | < 0.1% | |
| ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb5970129e9de77542ad | 1 | < 0.1% | |
| ffff04db2ba37d91b738fdac887d5744018d10c4d5504ffdfe1e2a5a192b236c | 1 | < 0.1% | |
| fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45ff69ff1b509fae1126 | 1 | < 0.1% |
idade_emp_cat
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 a 5 | |
|---|---|
| 5 a 10 | |
| > 20 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| 1 a 5 | 59888 | 29.9% | |
| 5 a 10 | 50244 | 25.1% | |
| > 20 | 32651 | 16.3% | |
| 10 a 15 | 21391 | 10.7% | |
| <= 1 | 20213 | 10.1% | |
| 15 a 20 | 15613 | 7.8% |
| Max length | 7 |
|---|---|
| Mean length | 5.35694 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
idade_empresa_anos
Numeric
| Distinct count | 12625 |
|---|---|
| Unique (%) | 6.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.947989959 |
|---|---|
| Minimum | 0.01643835616 |
| Maximum | 89.44383562 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.01643835616 |
|---|---|
| 5-th percentile | 0.4657534247 |
| Q1 | 2.767123288 |
| Median | 6.704109589 |
| Q3 | 14.45753425 |
| 95-th percentile | 30.15616438 |
| Maximum | 89.44383562 |
| Range | 89.42739726 |
| Interquartile range | 11.69041096 |
Descriptive statistics
| Standard deviation | 9.607973303 |
|---|---|
| Coef of variation | 0.965820567 |
| Kurtosis | 1.500814832 |
| Mean | 9.947989959 |
| MAD | 7.548775603 |
| Skewness | 1.373912367 |
| Sum | 1989597.992 |
| Variance | 92.31315099 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 0.2054794521 | 261 | 0.1% | |
| 0.2082191781 | 244 | 0.1% | |
| 0.202739726 | 199 | 0.1% | |
| 0.2164383562 | 140 | 0.1% | |
| 7.331506849 | 128 | 0.1% | |
| 8.021917808 | 123 | 0.1% | |
| 0.2438356164 | 120 | 0.1% | |
| 0.2 | 119 | 0.1% | |
| 7.334246575 | 116 | 0.1% | |
| 0.7452054795 | 114 | 0.1% | |
| Other values (12615) | 198436 | 99.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.01643835616 | 1 | < 0.1% | |
| 0.02739726027 | 11 | < 0.1% | |
| 0.0301369863 | 72 | < 0.1% | |
| 0.03287671233 | 85 | < 0.1% | |
| 0.03561643836 | 70 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 89.44383562 | 1 | < 0.1% | |
| 74.87123288 | 1 | < 0.1% | |
| 72.43013699 | 1 | < 0.1% | |
| 67.90136986 | 1 | < 0.1% | |
| 63.71506849 | 1 | < 0.1% |
idade_media_socios
Numeric
| Distinct count | 764 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 32.7% |
| Missing (n) | 65438 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42.81210697 |
|---|---|
| Minimum | 4 |
| Maximum | 127 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 33 |
| Median | 42 |
| Q3 | 51 |
| 95-th percentile | 65 |
| Maximum | 127 |
| Range | 123 |
| Interquartile range | 18 |
Descriptive statistics
| Standard deviation | 12.64238542 |
|---|---|
| Coef of variation | 0.2952993047 |
| Kurtosis | 0.1020027824 |
| Mean | 42.81210697 |
| MAD | 10.24207012 |
| Skewness | 0.5041636159 |
| Sum | 5760882.739 |
| Variance | 159.8299092 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 37 | 3757 | 1.9% | |
| 36 | 3748 | 1.9% | |
| 38 | 3604 | 1.8% | |
| 35 | 3562 | 1.8% | |
| 39 | 3515 | 1.8% | |
| 34 | 3510 | 1.8% | |
| 41 | 3496 | 1.7% | |
| 40 | 3489 | 1.7% | |
| 33 | 3489 | 1.7% | |
| 32 | 3370 | 1.7% | |
| Other values (753) | 99022 | 49.5% | |
| (Missing) | 65438 | 32.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 7.5 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 127 | 1 | < 0.1% | |
| 121 | 1 | < 0.1% | |
| 117 | 1 | < 0.1% | |
| 110 | 2 | < 0.1% | |
| 108 | 2 | < 0.1% |
natureza_juridica_macro
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| OUTROS | |
|---|---|
| ENTIDADES EMPRESARIAIS | |
| ENTIDADES SEM FINS LUCRATIVOS | 16088 |
| Other values (4) | 2526 |
| Value | Count | Frequency (%) | |
| OUTROS | 138512 | 69.3% | |
| ENTIDADES EMPRESARIAIS | 42874 | 21.4% | |
| ENTIDADES SEM FINS LUCRATIVOS | 16088 | 8.0% | |
| ADMINISTRACAO PUBLICA | 1305 | 0.7% | |
| CARGO POLITICO | 693 | 0.3% | |
| PESSOAS FISICAS | 527 | 0.3% | |
| INSTITUICOES EXTRATERRITORIAIS | 1 | < 0.1% |
| Max length | 30 |
|---|---|
| Mean length | 11.42947 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_divisao
Categorical
| Distinct count | 87 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| COMERCIO VAREJISTA | |
|---|---|
| ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | 16475 |
| ALIMENTACAO | 11876 |
| Other values (83) |
| Value | Count | Frequency (%) | |
| COMERCIO VAREJISTA | 74773 | 37.4% | |
| ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | 16475 | 8.2% | |
| ALIMENTACAO | 11876 | 5.9% | |
| COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 9633 | 4.8% | |
| COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | 7092 | 3.5% | |
| OUTRAS ATIVIDADES DE SERVICOS PESSOAIS | 6783 | 3.4% | |
| SERVICOS ESPECIALIZADOS PARA CONSTRUCAO | 6137 | 3.1% | |
| TRANSPORTE TERRESTRE | 4884 | 2.4% | |
| EDUCACAO | 4851 | 2.4% | |
| CONSTRUCAO DE EDIFICIOS | 4249 | 2.1% | |
| Other values (76) | 52455 | 26.2% |
| Max length | 120 |
|---|---|
| Mean length | 32.88121 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_meso_regiao
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 12.6% |
| Missing (n) | 25254 |
| CENTRO AMAZONENSE | |
|---|---|
| NORTE MARANHENSE | |
| LESTE POTIGUAR | |
| Other values (16) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CENTRO AMAZONENSE | 30864 | 15.4% | |
| NORTE MARANHENSE | 26524 | 13.3% | |
| LESTE POTIGUAR | 25571 | 12.8% | |
| CENTRO NORTE PIAUIENSE | 18283 | 9.1% | |
| OESTE MARANHENSE | 11590 | 5.8% | |
| OESTE POTIGUAR | 9076 | 4.5% | |
| LESTE MARANHENSE | 7588 | 3.8% | |
| VALE DO ACRE | 7181 | 3.6% | |
| CENTRO MARANHENSE | 6027 | 3.0% | |
| SUDOESTE PIAUIENSE | 5258 | 2.6% | |
| Other values (9) | 26784 | 13.4% | |
| (Missing) | 25254 | 12.6% |
| Max length | 22 |
|---|---|
| Mean length | 14.59602 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_micro_regiao
Categorical
| Distinct count | 74 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 12.6% |
| Missing (n) | 25254 |
| MANAUS | |
|---|---|
| NATAL | 20273 |
| AGLOMERACAO URBANA DE SAO LUIS | 19833 |
| Other values (70) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| MANAUS | 25887 | 12.9% | |
| NATAL | 20273 | 10.1% | |
| AGLOMERACAO URBANA DE SAO LUIS | 19833 | 9.9% | |
| TERESINA | 14630 | 7.3% | |
| IMPERATRIZ | 6829 | 3.4% | |
| RIO BRANCO | 6111 | 3.1% | |
| MOSSORO | 4646 | 2.3% | |
| PINDARE | 3619 | 1.8% | |
| MACAIBA | 3213 | 1.6% | |
| LITORAL PIAUIENSE | 2958 | 1.5% | |
| Other values (63) | 66747 | 33.4% | |
| (Missing) | 25254 | 12.6% |
| Max length | 33 |
|---|---|
| Mean length | 11.095095 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_segmento
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | |
|---|---|
| OUTRAS ATIVIDADES DE SERVICOS | |
| INDUSTRIAS DE TRANSFORMACAO | 13897 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 91498 | 45.7% | |
| OUTRAS ATIVIDADES DE SERVICOS | 25709 | 12.9% | |
| INDUSTRIAS DE TRANSFORMACAO | 13897 | 6.9% | |
| ALOJAMENTO E ALIMENTACAO | 13022 | 6.5% | |
| CONSTRUCAO | 11037 | 5.5% | |
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 9216 | 4.6% | |
| ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 7452 | 3.7% | |
| TRANSPORTE ARMAZENAGEM E CORREIO | 6618 | 3.3% | |
| EDUCACAO | 4851 | 2.4% | |
| SAUDE HUMANA E SERVICOS SOCIAIS | 4423 | 2.2% | |
| Other values (11) | 11485 | 5.7% |
| Max length | 65 |
|---|---|
| Mean length | 42.540665 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nu_meses_rescencia
Numeric
| Distinct count | 51 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 9.8% |
| Missing (n) | 19547 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.99726245 |
|---|---|
| Minimum | 0 |
| Maximum | 66 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 22 |
| Median | 23 |
| Q3 | 25 |
| 95-th percentile | 48 |
| Maximum | 66 |
| Range | 66 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 9.674244591 |
|---|---|
| Coef of variation | 0.3870121623 |
| Kurtosis | 1.961121154 |
| Mean | 24.99726245 |
| MAD | 5.873673916 |
| Skewness | 1.26387979 |
| Sum | 4510831 |
| Variance | 93.5910084 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 23 | 47070 | 23.5% | |
| 22 | 38641 | 19.3% | |
| 24 | 19297 | 9.6% | |
| 48 | 11375 | 5.7% | |
| 25 | 10805 | 5.4% | |
| 26 | 10475 | 5.2% | |
| 27 | 8130 | 4.1% | |
| 21 | 5283 | 2.6% | |
| 7 | 4371 | 2.2% | |
| 47 | 4218 | 2.1% | |
| Other values (40) | 20788 | 10.4% | |
| (Missing) | 19547 | 9.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 2 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 7 | 4371 | 2.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66 | 18 | < 0.1% | |
| 65 | 17 | < 0.1% | |
| 64 | 3 | < 0.1% | |
| 54 | 679 | 0.3% | |
| 53 | 14 | < 0.1% |
qt_filiais
Numeric
| Distinct count | 277 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 27.51195 |
|---|---|
| Minimum | 0 |
| Maximum | 9647 |
| Zeros (%) | 90.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 9647 |
| Range | 9647 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 459.1047766 |
|---|---|
| Coef of variation | 16.68746768 |
| Kurtosis | 374.733309 |
| Mean | 27.51195 |
| MAD | 53.66682345 |
| Skewness | 19.13128244 |
| Sum | 5502390 |
| Variance | 210777.1959 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 180959 | 90.5% | |
| 1 | 8441 | 4.2% | |
| 2 | 2549 | 1.3% | |
| 3 | 1238 | 0.6% | |
| 4 | 783 | 0.4% | |
| 5 | 489 | 0.2% | |
| 6 | 343 | 0.2% | |
| 7 | 294 | 0.1% | |
| 8 | 232 | 0.1% | |
| 10 | 213 | 0.1% | |
| Other values (267) | 4459 | 2.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 180959 | 90.5% | |
| 1 | 8441 | 4.2% | |
| 2 | 2549 | 1.3% | |
| 3 | 1238 | 0.6% | |
| 4 | 783 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9647 | 105 | 0.1% | |
| 9411 | 123 | 0.1% | |
| 9270 | 164 | 0.1% | |
| 7687 | 65 | < 0.1% | |
| 5491 | 39 | < 0.1% |
qt_socios
Numeric
| Distinct count | 47 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 24.8% |
| Missing (n) | 49616 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.484765667 |
|---|---|
| Minimum | 1 |
| Maximum | 153 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 153 |
| Range | 152 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 3.124724546 |
|---|---|
| Coef of variation | 2.104523708 |
| Kurtosis | 825.9712659 |
| Mean | 1.484765667 |
| MAD | 0.72188127 |
| Skewness | 26.71097273 |
| Sum | 223285 |
| Variance | 9.763903487 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 1 | 111971 | 56.0% | |
| 2 | 30747 | 15.4% | |
| 3 | 3831 | 1.9% | |
| 4 | 1395 | 0.7% | |
| 5 | 717 | 0.4% | |
| 6 | 420 | 0.2% | |
| 8 | 317 | 0.2% | |
| 7 | 263 | 0.1% | |
| 9 | 118 | 0.1% | |
| 96 | 105 | 0.1% | |
| Other values (36) | 500 | 0.2% | |
| (Missing) | 49616 | 24.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 111971 | 56.0% | |
| 2 | 30747 | 15.4% | |
| 3 | 3831 | 1.9% | |
| 4 | 1395 | 0.7% | |
| 5 | 717 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 153 | 1 | < 0.1% | |
| 142 | 1 | < 0.1% | |
| 139 | 1 | < 0.1% | |
| 109 | 15 | < 0.1% | |
| 96 | 105 | 0.1% |
qt_socios_feminino
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 68.6% |
| Missing (n) | 137299 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.107079632 |
|---|---|
| Minimum | 1 |
| Maximum | 93 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6837725746 |
|---|---|
| Coef of variation | 0.6176363063 |
| Kurtosis | 6196.851084 |
| Mean | 1.107079632 |
| MAD | 0.1977304021 |
| Skewness | 56.06299548 |
| Sum | 69415 |
| Variance | 0.4675449338 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 1 | 57891 | 28.9% | |
| 2 | 3974 | 2.0% | |
| 3 | 533 | 0.3% | |
| 4 | 148 | 0.1% | |
| 5 | 63 | < 0.1% | |
| 6 | 25 | < 0.1% | |
| 15 | 16 | < 0.1% | |
| 9 | 12 | < 0.1% | |
| 7 | 11 | < 0.1% | |
| 8 | 10 | < 0.1% | |
| Other values (12) | 18 | < 0.1% | |
| (Missing) | 137299 | 68.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 57891 | 28.9% | |
| 2 | 3974 | 2.0% | |
| 3 | 533 | 0.3% | |
| 4 | 148 | 0.1% | |
| 5 | 63 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 93 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% | |
| 25 | 2 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 22 | 2 | < 0.1% |
qt_socios_masculino
Highly correlated
This variable is highly correlated with qt_socios and should be ignored for analysis
| Correlation | 0.9711913029 |
|---|
qt_socios_pj
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 24.8% |
| Missing (n) | 49616 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01907117778 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 74.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1943337274 |
|---|---|
| Coef of variation | 10.18991745 |
| Kurtosis | 480.7900332 |
| Mean | 0.01907117778 |
| MAD | 0.03765867731 |
| Skewness | 16.26400576 |
| Sum | 2868 |
| Variance | 0.03776559759 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 148477 | 74.2% | |
| 1 | 1173 | 0.6% | |
| 2 | 602 | 0.3% | |
| 3 | 86 | < 0.1% | |
| 4 | 31 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 9 | 2 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| Other values (2) | 2 | < 0.1% | |
| (Missing) | 49616 | 24.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 148477 | 74.2% | |
| 1 | 1173 | 0.6% | |
| 2 | 602 | 0.3% | |
| 3 | 86 | < 0.1% | |
| 4 | 31 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 9 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 3 | < 0.1% |
setor
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| COMERCIO | |
|---|---|
| SERVIÇO | |
| INDUSTRIA | 13424 |
| Other values (2) | 12457 |
| Value | Count | Frequency (%) | |
| COMERCIO | 91498 | 45.7% | |
| SERVIÇO | 81829 | 40.9% | |
| INDUSTRIA | 13424 | 6.7% | |
| CONSTRUÇÃO CIVIL | 11037 | 5.5% | |
| AGROPECUARIA | 1420 | 0.7% | |
| (Missing) | 792 | 0.4% |
| Max length | 16 |
|---|---|
| Mean length | 8.108055 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
sg_uf
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MA | |
|---|---|
| RN | |
| AM | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| MA | 55257 | 27.6% | |
| RN | 42877 | 21.4% | |
| AM | 35370 | 17.7% | |
| PI | 33279 | 16.6% | |
| RO | 24317 | 12.2% | |
| AC | 8900 | 4.5% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sg_uf_matriz
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 795 |
| MA | |
|---|---|
| RN | |
| AM | |
| Other values (24) |
| Value | Count | Frequency (%) | |
| MA | 54056 | 27.0% | |
| RN | 42015 | 21.0% | |
| AM | 34489 | 17.2% | |
| PI | 32628 | 16.3% | |
| RO | 23662 | 11.8% | |
| AC | 8651 | 4.3% | |
| SP | 1258 | 0.6% | |
| DF | 505 | 0.3% | |
| CE | 404 | 0.2% | |
| RJ | 276 | 0.1% | |
| Other values (17) | 1261 | 0.6% | |
| (Missing) | 795 | 0.4% |
| Max length | 3 |
|---|---|
| Mean length | 2.003975 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Unnamed_0.1
Numeric
| Distinct count | 200000 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 99999.5 |
|---|---|
| Minimum | 0 |
| Maximum | 199999 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9999.95 |
| Q1 | 49999.75 |
| Median | 99999.5 |
| Q3 | 149999.25 |
| 95-th percentile | 189999.05 |
| Maximum | 199999 |
| Range | 199999 |
| Interquartile range | 99999.5 |
Descriptive statistics
| Standard deviation | 57735.17126 |
|---|---|
| Coef of variation | 0.5773545993 |
| Kurtosis | -1.2 |
| Mean | 99999.5 |
| MAD | 50000 |
| Skewness | 0 |
| Sum | 1.99999e+10 |
| Variance | 3333350000 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 152928 | 1 | < 0.1% | |
| 189814 | 1 | < 0.1% | |
| 195957 | 1 | < 0.1% | |
| 193908 | 1 | < 0.1% | |
| 183667 | 1 | < 0.1% | |
| 181618 | 1 | < 0.1% | |
| 187761 | 1 | < 0.1% | |
| 185712 | 1 | < 0.1% | |
| 142703 | 1 | < 0.1% | |
| Other values (199990) | 199990 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 199999 | 1 | < 0.1% | |
| 199998 | 1 | < 0.1% | |
| 199997 | 1 | < 0.1% | |
| 199996 | 1 | < 0.1% | |
| 199995 | 1 | < 0.1% |
vl_faturamento_estimado_aux
Numeric
| Distinct count | 1225 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 5.9% |
| Missing (n) | 11885 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 789491.3819 |
|---|---|
| Minimum | 0 |
| Maximum | 1.4546625e+10 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50000 |
| Q1 | 164851.2 |
| Median | 210000 |
| Q3 | 210000 |
| 95-th percentile | 947894.4 |
| Maximum | 1.4546625e+10 |
| Range | 1.4546625e+10 |
| Interquartile range | 45148.8 |
Descriptive statistics
| Standard deviation | 36398055.47 |
|---|---|
| Coef of variation | 46.1031701 |
| Kurtosis | 136074.6802 |
| Mean | 789491.3819 |
| MAD | 1096986.45 |
| Skewness | 346.5212661 |
| Sum | 1.485151713e+11 |
| Variance | 1.324818442e+15 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 210000 | 108120 | 54.1% | |
| 50000 | 40784 | 20.4% | |
| 930000 | 7060 | 3.5% | |
| 185457.6 | 3570 | 1.8% | |
| 370915.2 | 2796 | 1.4% | |
| 123638.4 | 2720 | 1.4% | |
| 247276.8 | 1675 | 0.8% | |
| 556372.8 | 1282 | 0.6% | |
| 741830.4 | 1220 | 0.6% | |
| 61819.2 | 943 | 0.5% | |
| Other values (1214) | 17945 | 9.0% | |
| (Missing) | 11885 | 5.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 507 | 0.3% | |
| 41212.8 | 849 | 0.4% | |
| 50000 | 40784 | 20.4% | |
| 51516 | 143 | 0.1% | |
| 61819.2 | 943 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.4546625e+10 | 1 | < 0.1% | |
| 3220831700 | 1 | < 0.1% | |
| 2068779500 | 1 | < 0.1% | |
| 2048888000 | 1 | < 0.1% | |
| 1489842700 | 1 | < 0.1% |
vl_faturamento_estimado_grupo_aux
Numeric
| Distinct count | 4416 |
|---|---|
| Unique (%) | 2.2% |
| Missing (%) | 5.9% |
| Missing (n) | 11885 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 306243925.2 |
|---|---|
| Minimum | 41212.8 |
| Maximum | 2.227618e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 41212.8 |
|---|---|
| 5-th percentile | 50000 |
| Q1 | 185457.6 |
| Median | 210000 |
| Q3 | 210000 |
| 95-th percentile | 2827058.91 |
| Maximum | 2.227618e+11 |
| Range | 2.227617588e+11 |
| Interquartile range | 24542.4 |
Descriptive statistics
| Standard deviation | 6677856568 |
|---|---|
| Coef of variation | 21.80567848 |
| Kurtosis | 837.9308527 |
| Mean | 306243925.2 |
| MAD | 602867603.8 |
| Skewness | 28.13600343 |
| Sum | 5.760907598e+13 |
| Variance | 4.459376835e+19 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 210000 | 99930 | 50.0% | |
| 50000 | 40784 | 20.4% | |
| 930000 | 5612 | 2.8% | |
| 185457.6 | 3111 | 1.6% | |
| 420000 | 2999 | 1.5% | |
| 123638.4 | 2450 | 1.2% | |
| 370915.2 | 2387 | 1.2% | |
| 247276.8 | 1455 | 0.7% | |
| 556372.8 | 1075 | 0.5% | |
| 741830.4 | 1028 | 0.5% | |
| Other values (4405) | 27284 | 13.6% | |
| (Missing) | 11885 | 5.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 41212.8 | 773 | 0.4% | |
| 50000 | 40784 | 20.4% | |
| 51516 | 135 | 0.1% | |
| 61819.2 | 820 | 0.4% | |
| 82425.6 | 257 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.227618e+11 | 65 | < 0.1% | |
| 1.8943014e+11 | 105 | 0.1% | |
| 1.8120853e+11 | 15 | < 0.1% | |
| 1.2398112e+11 | 4 | < 0.1% | |
| 1.009873e+11 | 8 | < 0.1% |
vl_total_veiculos_leves_grupo
Numeric
| Distinct count | 250 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 48.27108349 |
|---|---|
| Minimum | 0 |
| Maximum | 122090 |
| Zeros (%) | 91.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 122090 |
| Range | 122090 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1212.466738 |
|---|---|
| Coef of variation | 25.11786872 |
| Kurtosis | 1708.785325 |
| Mean | 48.27108349 |
| MAD | 95.14304612 |
| Skewness | 35.27165009 |
| Sum | 9615986 |
| Variance | 1470075.591 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 183714 | 91.9% | |
| 1 | 6793 | 3.4% | |
| 2 | 2247 | 1.1% | |
| 3 | 1111 | 0.6% | |
| 4 | 670 | 0.3% | |
| 5 | 460 | 0.2% | |
| 6 | 333 | 0.2% | |
| 7 | 269 | 0.1% | |
| 8 | 231 | 0.1% | |
| 10 | 176 | 0.1% | |
| Other values (239) | 3204 | 1.6% | |
| (Missing) | 792 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 183714 | 91.9% | |
| 1 | 6793 | 3.4% | |
| 2 | 2247 | 1.1% | |
| 3 | 1111 | 0.6% | |
| 4 | 670 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 122090 | 1 | < 0.1% | |
| 105312 | 1 | < 0.1% | |
| 96763 | 1 | < 0.1% | |
| 44229 | 1 | < 0.1% | |
| 44175 | 1 | < 0.1% |
vl_total_veiculos_pesados_grupo
Numeric
| Distinct count | 228 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 792 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.454509859 |
|---|---|
| Minimum | 0 |
| Maximum | 3674 |
| Zeros (%) | 95.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 3674 |
| Range | 3674 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 69.53233698 |
|---|---|
| Coef of variation | 20.12798916 |
| Kurtosis | 868.4489056 |
| Mean | 3.454509859 |
| MAD | 6.71861698 |
| Skewness | 27.93113919 |
| Sum | 688166 |
| Variance | 4834.745886 |
| Memory size | 8.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 191111 | 95.6% | |
| 1 | 2913 | 1.5% | |
| 2 | 1105 | 0.6% | |
| 3 | 548 | 0.3% | |
| 4 | 378 | 0.2% | |
| 5 | 278 | 0.1% | |
| 7 | 230 | 0.1% | |
| 6 | 198 | 0.1% | |
| 1177 | 164 | 0.1% | |
| 8 | 128 | 0.1% | |
| Other values (217) | 2155 | 1.1% | |
| (Missing) | 792 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 191111 | 95.6% | |
| 1 | 2913 | 1.5% | |
| 2 | 1105 | 0.6% | |
| 3 | 548 | 0.3% | |
| 4 | 378 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3674 | 1 | < 0.1% | |
| 2710 | 1 | < 0.1% | |
| 2693 | 4 | < 0.1% | |
| 2347 | 105 | 0.1% | |
| 2151 | 1 | < 0.1% |
First rows
| de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | id | idade_emp_cat | idade_empresa_anos | idade_media_socios | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | qt_filiais | qt_socios | qt_socios_feminino | qt_socios_masculino | qt_socios_pj | setor | sg_uf | sg_uf_matriz | Unnamed_0.1 | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DE R$ 1.500.000,01 A R$ 4.800.000,00 | DE R$ 1.500.000,01 A R$ 4.800.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | INDUSTRIA DA CONSTRUCAO | ACIMA DE 1 ANO | VERDE | 2005-03-25 | NaN | False | True | False | False | True | False | False | False | True | True | SIM | False | False | False | False | True | False | a6984c3ae395090e3bee8ad63c3758b110de096d5d8195... | 10 a 15 | 14.457534 | 44.0 | ENTIDADES EMPRESARIAIS | CONSTRUCAO DE EDIFICIOS | LESTE POTIGUAR | NATAL | CONSTRUCAO | 23.0 | 0 | 2.0 | NaN | 2.0 | 0.0 | CONSTRUÇÃO CIVIL | RN | RN | 0 | 3132172.8 | 3132172.8 | 0.0 | 0.0 |
| 1 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | BAIXA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ATE 1 ANO | CINZA | 2017-05-12 | 468.93 | False | True | False | False | True | False | True | NaN | NaN | True | SIM | False | False | False | False | True | False | 6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4... | 1 a 5 | 1.463014 | 27.0 | OUTROS | ALIMENTACAO | CENTRO NORTE PIAUIENSE | TERESINA | ALOJAMENTO E ALIMENTACAO | 9.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | SERVIÇO | PI | PI | 1 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 2 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | TRANSPORTE, ARMAZENAGEM E CORREIO | ACIMA DE 1 ANO | AMARELO | 2011-09-26 | 713.50 | False | False | False | False | True | False | True | True | True | True | SIM | False | False | False | False | True | False | 4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02... | 5 a 10 | 7.093151 | 32.0 | OUTROS | TRANSPORTE TERRESTRE | CENTRO AMAZONENSE | MANAUS | TRANSPORTE ARMAZENAGEM E CORREIO | 26.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | SERVIÇO | AM | AM | 2 | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 3 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | SERVICOS DIVERSOS | ACIMA DE 1 ANO | AMARELO | 2012-04-25 | 475.73 | False | True | False | False | True | False | False | False | True | True | SIM | False | False | False | False | True | False | 3348900fe63216a439d2e5238c79ddd46ede454df7b9d8... | 5 a 10 | 6.512329 | 36.0 | OUTROS | REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO... | CENTRO AMAZONENSE | MANAUS | OUTRAS ATIVIDADES DE SERVICOS | 26.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | SERVIÇO | AM | AM | 3 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 4 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2015-08-17 | 2874.04 | False | True | False | False | True | False | False | False | True | True | SIM | False | False | False | False | True | False | 1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4... | 1 a 5 | 3.200000 | NaN | OUTROS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ... | LESTE POTIGUAR | NATAL | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 27.0 | 0 | 1.0 | NaN | NaN | 0.0 | SERVIÇO | RN | RN | 4 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 5 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | QUIMICA-PETROQUIMICA | ACIMA DE 1 ANO | LARANJA | 2005-11-03 | NaN | False | False | False | False | True | False | False | False | False | False | NAO | False | False | False | False | False | False | 529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6... | > 20 | 38.079452 | NaN | ENTIDADES EMPRESARIAIS | FABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOS | OESTE POTIGUAR | PAU DOS FERROS | INDUSTRIAS DE TRANSFORMACAO | 48.0 | 0 | NaN | NaN | NaN | NaN | INDUSTRIA | RN | RN | 5 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 6 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | TRANSPORTE, ARMAZENAGEM E CORREIO | ACIMA DE 1 ANO | AMARELO | 2011-07-21 | NaN | False | True | False | False | True | False | True | True | True | True | SIM | False | False | False | False | False | False | 8bf37c178778e537b108e58bf20552abe10c3a7fae129b... | 5 a 10 | 7.276712 | 63.0 | OUTROS | TRANSPORTE TERRESTRE | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | TRANSPORTE ARMAZENAGEM E CORREIO | 23.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | SERVIÇO | MA | MA | 6 | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 7 | NaN | NaN | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS ADMINISTRATIVOS | NaN | NaN | 2018-10-09 | NaN | False | True | False | False | True | False | True | NaN | NaN | True | SIM | False | False | False | False | True | False | 0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d... | <= 1 | 0.052055 | 40.0 | OUTROS | AGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE... | LESTE POTIGUAR | NATAL | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | NaN | 0 | 1.0 | 1.0 | NaN | 0.0 | SERVIÇO | RN | RN | 7 | NaN | NaN | 0.0 | 0.0 |
| 8 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | COOPERATIVA | ALTA | BENS DE CONSUMO | ACIMA DE 1 ANO | AZUL | 2006-07-27 | 247.88 | False | False | False | False | True | False | False | False | True | True | NAO | False | False | False | False | True | False | 6c45aabb849a760a3a7107c7a61262642f683feb8912a4... | 10 a 15 | 12.263014 | 36.0 | ENTIDADES EMPRESARIAIS | FABRICACAO DE PRODUTOS DIVERSOS | CENTRO AMAZONENSE | PARINTINS | INDUSTRIAS DE TRANSFORMACAO | 24.0 | 0 | 2.0 | NaN | 1.0 | 0.0 | INDUSTRIA | AM | AM | 8 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 9 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 360.000,01 A R$ 1.500.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERMELHO | 2004-10-30 | 1042.85 | False | False | False | False | False | False | False | False | False | False | NAO | False | False | False | False | False | False | 2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926... | 15 a 20 | 17.942466 | 52.0 | OUTROS | COMERCIO VAREJISTA | OESTE POTIGUAR | MOSSORO | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 54.0 | 3 | 1.0 | NaN | 1.0 | 0.0 | COMERCIO | RN | RN | 9 | 210000.0 | 840000.0 | 0.0 | 0.0 |
Last rows
| de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | id | idade_emp_cat | idade_empresa_anos | idade_media_socios | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | qt_filiais | qt_socios | qt_socios_feminino | qt_socios_masculino | qt_socios_pj | setor | sg_uf | sg_uf_matriz | Unnamed_0.1 | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199990 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | AZUL | 2013-08-08 | 958.09 | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | False | b3842201eb905c46f0eb4a7b93a7ff34388d3e3f8f83c2... | 5 a 10 | 5.224658 | NaN | OUTROS | SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO... | NORTE MARANHENSE | LENCOIS MARANHENSES | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | 23.0 | 0 | NaN | NaN | NaN | NaN | SERVIÇO | MA | MA | 199990 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 199991 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | AMARELO | 2005-11-03 | NaN | False | False | False | False | True | False | False | False | False | False | SIM | False | False | False | False | False | False | 5057d28fa6432ccf08a7d2c7b3b6a069962392b5265531... | 15 a 20 | 16.558904 | 47.0 | OUTROS | COMERCIO VAREJISTA | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 24.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | COMERCIO | MA | MA | 199991 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 199992 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS DIVERSOS | ACIMA DE 1 ANO | VERDE | 2008-12-30 | NaN | False | True | False | False | True | False | False | True | True | True | NAO | False | False | False | False | True | False | 7665c89ce3d3cd35a8c1f71472da744e78a44115a2a371... | 5 a 10 | 9.832877 | NaN | OUTROS | OUTRAS ATIVIDADES DE SERVICOS PESSOAIS | OESTE POTIGUAR | SERRA DE SAO MIGUEL | OUTRAS ATIVIDADES DE SERVICOS | 23.0 | 0 | 1.0 | NaN | NaN | 0.0 | SERVIÇO | RN | RN | 199992 | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 199993 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ACIMA DE 1 ANO | VERDE | 2011-02-25 | NaN | False | False | False | False | True | False | True | True | True | True | SIM | False | False | False | False | True | False | 6b836412910d230bcba8c9d14aa588bf5dfcd7c37859b2... | 5 a 10 | 7.676712 | 40.0 | OUTROS | ALIMENTACAO | CENTRO AMAZONENSE | ITACOATIARA | ALOJAMENTO E ALIMENTACAO | 25.0 | 0 | 1.0 | 1.0 | NaN | 0.0 | SERVIÇO | AM | AM | 199993 | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 199994 | NaN | NaN | SOCIEDADE EMPRESARIA LIMITADA | NaN | INDUSTRIA DA CONSTRUCAO | NaN | NaN | 2017-08-03 | NaN | False | True | False | False | False | False | False | NaN | NaN | False | SIM | False | False | False | False | True | False | af91fa4a0cafef1a39e2c79e9eaf0f76344be166cd081e... | 1 a 5 | 1.235616 | 47.0 | ENTIDADES EMPRESARIAIS | CONSTRUCAO DE EDIFICIOS | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | CONSTRUCAO | NaN | 4 | 2.0 | 1.0 | 1.0 | 0.0 | CONSTRUÇÃO CIVIL | MA | MA | 199994 | NaN | NaN | 3.0 | 3.0 |
| 199995 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | SOCIEDADE EMPRESARIA LIMITADA | MEDIA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ACIMA DE 1 ANO | AZUL | 2013-09-27 | 707.86 | False | False | False | False | True | False | False | False | True | True | SIM | False | False | False | False | True | False | 47374fcdc31fe94bc9190e9c5d31ee8976307f8082bff1... | 5 a 10 | 5.087671 | 72.0 | ENTIDADES EMPRESARIAIS | ALIMENTACAO | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | ALOJAMENTO E ALIMENTACAO | 22.0 | 0 | 2.0 | NaN | 1.0 | 0.0 | SERVIÇO | MA | MA | 199995 | 247276.8 | 247276.8 | 0.0 | 0.0 |
| 199996 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO POR ATACADO | ACIMA DE 1 ANO | AZUL | 2008-02-15 | 1443.43 | False | False | False | False | True | False | False | False | False | False | NAO | False | False | False | False | True | False | 8a14502b3bfdd18f702df8895a800c4bba3bfd42f10028... | 10 a 15 | 10.706849 | NaN | OUTROS | COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR... | NaN | NaN | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 24.0 | 0 | NaN | NaN | NaN | NaN | COMERCIO | RO | RO | 199996 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 199997 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERDE | 2013-04-24 | NaN | False | False | False | False | True | False | True | True | True | False | NAO | False | False | False | False | True | False | ba3b7f728587f83023464d54ea06fa5628b3ba8d1aeeb0... | 5 a 10 | 5.515068 | 46.0 | OUTROS | COMERCIO VAREJISTA | LESTE MARANHENSE | CHAPADAS DO ALTO ITAPECURU | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 24.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | COMERCIO | MA | MA | 199997 | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 199998 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | BAIXA | SERVICOS DIVERSOS | ATE 1 ANO | CINZA | 2017-07-17 | NaN | False | True | False | False | True | False | True | NaN | NaN | True | NAO | False | False | False | False | True | False | eb4ddd433569ecc02bceb40901ba56ba786d48b946e9a4... | 1 a 5 | 1.282192 | 22.0 | OUTROS | REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO... | NaN | NaN | OUTRAS ATIVIDADES DE SERVICOS | 7.0 | 0 | 1.0 | NaN | 1.0 | 0.0 | SERVIÇO | RO | RO | 199998 | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 199999 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | INDUSTRIA DA CONSTRUCAO | ACIMA DE 1 ANO | VERDE | 2012-05-17 | 439.41 | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | False | 099b001d8cdbae0c349cf66c3b0fe1f04c27a06ac58b6d... | 5 a 10 | 6.452055 | 45.0 | ENTIDADES EMPRESARIAIS | CONSTRUCAO DE EDIFICIOS | OESTE POTIGUAR | PAU DOS FERROS | CONSTRUCAO | 48.0 | 0 | 2.0 | 2.0 | NaN | 0.0 | CONSTRUÇÃO CIVIL | RN | RN | 199999 | 210000.0 | 210000.0 | 0.0 | 0.0 |